Back to Tutorials
SQL Tutorial Topics
Basics
Introduction to SQL
-
What is SQL?
-
Setting up a SQL environment
-
Basic SQL syntax
Basic Queries
-
SELECT statement
-
WHERE clause
-
ORDER BY and LIMIT clauses
Joins
-
INNER JOIN
-
LEFT JOIN
-
RIGHT JOIN and FULL JOIN
Intermediate
Advanced Queries
-
GROUP BY and HAVING clauses
-
Subqueries
-
Common Table Expressions (CTEs)
Data Modification
-
INSERT statement
-
UPDATE statement
-
DELETE and MERGE statements
Indexes and Transactions
-
Creating and using indexes
-
Starting and committing transactions
-
Transaction isolation levels
Advanced
Stored Procedures and Functions
-
Creating stored procedures
-
Creating functions
-
Parameters and error handling
Triggers
-
Creating triggers
-
AFTER and BEFORE triggers
-
INSTEAD OF triggers
Performance and Security
-
Query optimization and execution plans
-
Managing users and roles
-
SQL injection prevention